Install Expere Database

The InstallExpereDM.ps1 (PowerShell) file installs the Expere Database based on input parameters (see parameters below) and adds seed data required to the Types and Stores tables.

  1. Open Windows PowerShell console.
  2. Navigate to the folder where the InstallExpereDM.ps1 file is located.
  3. Run InstallExpereDM.ps1 using following parameters:

    Parameter Description
    –DBServer “<host>[,<port>]”

    <host> - Required. Fully qualified, short name or IP address of the target host where Expere DB should be installed;

    <port> - Optional. TCP port used to host MS SQL Server instance, if not provided then defaults to 1433.

    –DBName “<name>”

    Required – target Expere Database name.
    -ACCOUNTDOMAIN “<name>”

    Required – The Account Domain and Domain Account User that has access rights to the DOCGEN Database. Specifying these parameters will add the user to the Expere Database and assign the following roles (db_owner, db_datareader, db_datawriter).

    -DOMAINACCOUNT “<name>”

    Example Powershell Command Syntax: 
    .\InstallExpereDM.ps1 –DBServer “example.domain.com,1433” –DBName “ExpereDB” -ACCOUNTDOMAIN “NA” –DOMAINACCOUNT “DGS-USER”